Applied Microsoft Power BI (2nd Edition) by Lachev Teo

Author:Lachev, Teo
Language: eng
Format: epub
Publisher: Prologika Press
Published: 2017-01-18T00:00:00+00:00

NOTE Power BI Desktop automatically inherits the data collation based on the language selection in your Windows regional settings, which you can overwrite in the Options and Settings ð Option ð Data Load (Current File section). The default collations are case-insensitive. Consequently, if you have a source column with the values "John" and "JOHn", then Power BI Desktop imports both values as "John" and treats them the same. While this behavior helps the xVelocity storage engine compress data efficiently, sometimes a case-sensitive collation might be preferable, such as when you need a unique key to set up a relationship, and you get an error that the column contains duplicate values. However, currently there isn't an easy way to change the collation and configure a given field or a table to be case-sensitive. So you'll need to try to keep the column names distinct.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.